www.gusucode.com > VC++ 宾馆管理系统(MSSQL) > VC++ 宾馆管理系统(MSSQL)/gusucode/Code/SearchCheckOutDLG.cpp
//Download by http://www.NewXing.com // SearchCheckOutDLG.cpp : implementation file // #include "stdafx.h" #include "hotel_mis.h" #include "SearchCheckOutDLG.h" #include "Hotel_MISView.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CSearchCheckOutDLG dialog CSearchCheckOutDLG::CSearchCheckOutDLG(CWnd* pParent /*=NULL*/) : CDialog(CSearchCheckOutDLG::IDD, pParent) { //{{AFX_DATA_INIT(CSearchCheckOutDLG) m_tInDate = COleDateTime::GetCurrentTime(); m_bInDate = FALSE; m_sName = _T(""); m_bName = true; m_sRoomNo = _T(""); m_bRoomNo = FALSE; //}}AFX_DATA_INIT } void CSearchCheckOutDLG::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CSearchCheckOutDLG) DDX_DateTimeCtrl(pDX, IDD_SEARCHCHECKOUT_INDATE, m_tInDate); DDX_Check(pDX, IDD_SEARCHCHECKOUT_INDATECHECK, m_bInDate); DDX_Text(pDX, IDD_SEARCHCHECKOUT_NAME, m_sName); DDX_Check(pDX, IDD_SEARCHCHECKOUT_NAMECHECK, m_bName); DDX_Text(pDX, IDD_SEARCHCHECKOUT_NO, m_sRoomNo); DDX_Check(pDX, IDD_SEARCHCHECKOUT_NOCHECK, m_bRoomNo); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CSearchCheckOutDLG, CDialog) //{{AFX_MSG_MAP(CSearchCheckOutDLG) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CSearchCheckOutDLG message handlers void CSearchCheckOutDLG::OnOK() { // TODO: Add extra validation here UpdateData(true); m_sName.TrimRight(" "); m_sRoomNo.TrimRight(" "); if ( !(m_bName||m_bRoomNo||m_bInDate) ) { AfxMessageBox(_T("请选择查询条件!"), MB_ICONEXCLAMATION); return; } if ( m_bName && ""==m_sName ) { AfxMessageBox(_T("顾客姓名不能为空"), MB_ICONEXCLAMATION); return; } if ( m_bRoomNo && ""==m_sRoomNo ) { AfxMessageBox(_T("客房编号不能为空"), MB_ICONEXCLAMATION); return; } CString sTime = m_tInDate.Format("%Y-%m-%d"); if ( !m_bName ) m_sName = "%"; if ( !m_bRoomNo ) m_sRoomNo = "%"; _variant_t strQuery; if ( !m_bInDate ) strQuery = "select * from bookin where customname like '"+m_sName+"' and roomno like '"+m_sRoomNo+"' and checkdate is not NULL"; else strQuery = "select * from bookin where customname like '"+m_sName+"' and roomno like '"+m_sRoomNo+"' and indate='"+sTime+"' and checkdate is not NULL"; CHotel_MISView* p = (CHotel_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView()); p->RefreshCheckOut(strQuery); //CDialog::OnOK(); }